package com.hongdee.crm.insurance.entity;

import com.hongdee.annotation.ExcelData;
import com.hongdee.base.entity.BaseEntity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;

/**
 * 名  称:TCrmCarInsurance
 * 类  型: class
 * 描  述: 通过 token取用户信息
 * 路  径:com.hongdee.crm.insurance.entity.TCrmCarInsurance;
 * 作  者: 术洪超
 * 日  期:2017-02-14 17:44
 */
@Entity
@Table(name = "T_CRM_CAR_INSURANCE")
public class TCrmCarInsurance extends BaseEntity {

    //被保险人姓名
    @ExcelData("被保险人姓名")
    @Column(name = "user_name", length = 32, columnDefinition = "VARCHAR(32) COMMENT '被保险人姓名'")
    private String userName;

    //车牌号
    @ExcelData("车牌号")
    @Column(name = "plate_num", length = 10, columnDefinition = "VARCHAR(10) COMMENT '车牌号'")
    private String plateNum;

    //商业险公司名
    @ExcelData("商业险承保公司")
    @Column(name = "commercial_company", length = 32, columnDefinition = "VARCHAR(32) COMMENT '商业险公司名'")
    private String commercialCompany;

    //用户车辆 ID
    @Column(name = "user_carid", length = 32, columnDefinition = "VARCHAR(32) COMMENT '用户车辆 ID'")
    private String userCarId;

    //商业险合同号
    @ExcelData("商业险保单号")
    @Column(name = "commercialinsurancenum", length = 64, columnDefinition = "VARCHAR(64) COMMENT '商业险合同号'")
    private String commercialinsurancenum;

    //商业险开始时间
    @ExcelData("商业险开始时间")
    @Column(name = "contractstartinsurance", length = 22, columnDefinition = "BIGINT COMMENT '商业险开始时间'")
    private Long contractstartinsurance;


    //交强险公司名
    @ExcelData("交强险承保公司")
    @Column(name = "compulsory_company", length = 32, columnDefinition = "VARCHAR(32) COMMENT '交强险公司名'")
    private String compulsoryCompany;

    //交强险合同号
    @ExcelData("交强险保单号")
    @Column(name = "compulsoryinsurancenum", length = 64, columnDefinition = "VARCHAR(64) COMMENT '交强险合同号'")
    private String compulsoryinsurancenum;


    //交强险开始时间
    @ExcelData("交强险开始时间")
    @Column(name = "compulsory_start_date", length = 22, columnDefinition = "BIGINT COMMENT '交强险开始时间'")
    private Long compulsoryStartDate;


    //基盘类型
    @ExcelData("基盘类型")
    @Column(name = "base_type", length = 32, columnDefinition = "VARCHAR(32) COMMENT '基盘类型'")
    private String baseType;

    //车架号
    @ExcelData("车架号")
    @Column(name = "vin", length = 32, columnDefinition = "VARCHAR(32) COMMENT '车架号'")
    private String vin;

    //联系电话
    @ExcelData("联系电话")
    @Column(name = "user_tel", length = 256, columnDefinition = "VARCHAR(256) COMMENT '联系电话'")
    private String userTel;

    //玻璃险
    @ExcelData("玻璃险")
    @Column(name = "boli", length = 11, columnDefinition = "VARCHAR(10) COMMENT '玻璃险'")
    private String boli;

    //交强险开始时间
    @ExcelData("玻璃险开始时间")
    @Column(name = "boli_start_date", length = 22, columnDefinition = "BIGINT COMMENT '玻璃险开始时间'")
    private Long boliStartDate;
    //划痕险
    @ExcelData("划痕险")
    @Column(name = "huahen", length = 11, columnDefinition = "VARCHAR(10) COMMENT '划痕险'")
    private String huahen;

    //交强险开始时间
    @ExcelData("划痕险开始时间")
    @Column(name = "huahen_start_date", length = 22, columnDefinition = "BIGINT COMMENT '划痕险开始时间'")
    private Long huahenStartDate;

    //商业险到期时间
    @Column(name = "contractstopinsurance", length = 22, columnDefinition = "BIGINT COMMENT '商业险到期时间'")
    private Long contractstopinsurance;

    //是否单交强险 0交强 商业都有 1单交强 2 单商业
    @Column(name = "iscompulsoryinsurance", length = 10, columnDefinition = "VARCHAR(10) COMMENT '是否单交强险'")
    private String isccompulsoryinsurance;

    //类型 新保 新保续 续保续 转保续
    @Column(name = "type", length = 32, columnDefinition = "VARCHAR(32) COMMENT '类型'")
    private String type;


    //玻璃险到期时间
    @Column(name = "boli_end_date", length = 22, columnDefinition = "BIGINT COMMENT '玻璃险到期时间'")
    private Long boliEndDate;


    //划痕险到期时间
    @Column(name = "huahen_end_date", length = 22, columnDefinition = "BIGINT COMMENT '划痕险到期时间'")
    private Long huahenEndDate;


    //交强险到期时间
    @Column(name = "compulsory_end_date", length = 22, columnDefinition = "BIGINT COMMENT '交强险到期时间'")
    private Long compulsoryEndDate;


    //车系代码
    @ExcelData("车系")
    @Column(name = "car_series", length = 32, columnDefinition = "VARCHAR(128) COMMENT '车系代码'")
    private String carSeries;

    //车辆质保开始时间
    @Column(name = "age_start_date", length = 22, columnDefinition = "BIGINT COMMENT '车辆质保开始时间'")
    private Long ageStartDate;


    //导入公司ID
    @Column(name = "company_id", length = 32, columnDefinition = "VARCHAR(32) COMMENT '导入公司ID'")
    private String companyId;
    //确认人
    @Column(name = "confirmer", length = 32, columnDefinition = "VARCHAR(32) COMMENT '确认人'")
    private String confirmer;
    //确认时间
    @Column(name = "confirm_date", length = 22, columnDefinition = "BIGINT COMMENT '确认时间'")
    private Long confirmDate;

    @Column(name = "continuation", length = 32, columnDefinition = "VARCHAR(32) COMMENT '连续保险状态'")
    private String continuation;

    @ExcelData("门店")
    @Column(name = "store_name", length = 64, columnDefinition = "VARCHAR(63) COMMENT '门店'")
    private String storeName;

    @ExcelData("大区区域")
    @Column(name = "store_p_area", length = 64, columnDefinition = "VARCHAR(64) COMMENT '大区域'")
    private String storeParea;



    @ExcelData("区域")
    @Column(name = "store_area", length = 64, columnDefinition = "VARCHAR(64) COMMENT '区域'")
    private String storeArea;

    @Column(name = "store_area_code", length = 64, columnDefinition = "VARCHAR(64) COMMENT '大区域编码'")
    private String storeAreaCode;
    @Column(name = "store_p_area_code", length = 64, columnDefinition = "VARCHAR(64) COMMENT '大区域编码'")
    private String storePareaCode;
    @Column(name = "store_code", length = 64, columnDefinition = "VARCHAR(63) COMMENT '门店编码'")
    private String storeCode;

    public String getStoreCode() {
        return storeCode;
    }

    public void setStoreCode(String storeCode) {
        this.storeCode = storeCode;
    }

    public String getStorePareaCode() {
        return storePareaCode;
    }

    public void setStorePareaCode(String storePareaCode) {
        this.storePareaCode = storePareaCode;
    }

    public String getStoreAreaCode() {
        return storeAreaCode;
    }

    public void setStoreAreaCode(String storeAreaCode) {
        this.storeAreaCode = storeAreaCode;
    }

    @ExcelData("渠道")
    @Column(name = "store_chanel", length = 64, columnDefinition = "VARCHAR(64) COMMENT '渠道分类'")
    private String storeChanel;

    @ExcelData("销售顾问")
    @Column(name = "sale", length = 64, columnDefinition = "VARCHAR(64) COMMENT '销售顾问'")
    private String sale;

    public String getStoreParea() {
        return storeParea;
    }

    public void setStoreParea(String storeParea) {
        this.storeParea = storeParea;
    }

    //上牌日期
    @ExcelData("上牌日期")
    @Column(name = "licence_date", length = 22, columnDefinition = "BIGINT COMMENT '上牌日期'")
    private Long licenceDate;

    public Long getLicenceDate() {
        return licenceDate;
    }

    public void setLicenceDate(Long licenceDate) {
        this.licenceDate = licenceDate;
    }

    public String getStoreChanel() {
        return storeChanel;
    }

    public void setStoreChanel(String storeChanel) {
        this.storeChanel = storeChanel;
    }

    public String getSale() {
        return sale;
    }

    public void setSale(String sale) {
        this.sale = sale;
    }

    public String getContinuation() {
        return continuation;
    }

    public void setContinuation(String continuation) {
        this.continuation = continuation;
    }

    public String getStoreName() {
        return storeName;
    }

    public void setStoreName(String storeName) {
        this.storeName = storeName;
    }

    public String getStoreArea() {
        return storeArea;
    }

    public void setStoreArea(String storeArea) {
        this.storeArea = storeArea;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getPlateNum() {
        return plateNum;
    }

    public void setPlateNum(String plateNum) {
        this.plateNum = plateNum;
    }

    public String getCommercialCompany() {
        return commercialCompany;
    }

    public void setCommercialCompany(String commercialCompany) {
        this.commercialCompany = commercialCompany;
    }

    public String getUserCarId() {
        return userCarId;
    }

    public void setUserCarId(String userCarId) {
        this.userCarId = userCarId;
    }



    public String getCompulsoryCompany() {
        return compulsoryCompany;
    }

    public void setCompulsoryCompany(String compulsoryCompany) {
        this.compulsoryCompany = compulsoryCompany;
    }



    public Long getCompulsoryStartDate() {
        return compulsoryStartDate;
    }

    public void setCompulsoryStartDate(Long compulsoryStartDate) {
        this.compulsoryStartDate = compulsoryStartDate;
    }

    public String getBaseType() {
        return baseType;
    }

    public void setBaseType(String baseType) {
        this.baseType = baseType;
    }

    public String getVin() {
        return vin;
    }

    public void setVin(String vin) {
        this.vin = vin;
    }

    public String getUserTel() {
        return userTel;
    }

    public void setUserTel(String userTel) {
        this.userTel = userTel;
    }

    public String getBoli() {
        return boli;
    }

    public void setBoli(String boli) {
        this.boli = boli;
    }

    public Long getBoliStartDate() {
        return boliStartDate;
    }

    public void setBoliStartDate(Long boliStartDate) {
        this.boliStartDate = boliStartDate;
    }

    public String getHuahen() {
        return huahen;
    }

    public void setHuahen(String huahen) {
        this.huahen = huahen;
    }

    public Long getHuahenStartDate() {
        return huahenStartDate;
    }

    public void setHuahenStartDate(Long huahenStartDate) {
        this.huahenStartDate = huahenStartDate;
    }


    public String getType() {
        return type;
    }

    public void setType(String type) {
        this.type = type;
    }

    public Long getBoliEndDate() {
        return boliEndDate;
    }

    public void setBoliEndDate(Long boliEndDate) {
        this.boliEndDate = boliEndDate;
    }

    public Long getHuahenEndDate() {
        return huahenEndDate;
    }

    public void setHuahenEndDate(Long huahenEndDate) {
        this.huahenEndDate = huahenEndDate;
    }

    public Long getCompulsoryEndDate() {
        return compulsoryEndDate;
    }

    public void setCompulsoryEndDate(Long compulsoryEndDate) {
        this.compulsoryEndDate = compulsoryEndDate;
    }

    public String getCarSeries() {
        return carSeries;
    }

    public void setCarSeries(String carSeries) {
        this.carSeries = carSeries;
    }

    public Long getAgeStartDate() {
        return ageStartDate;
    }

    public void setAgeStartDate(Long ageStartDate) {
        this.ageStartDate = ageStartDate;
    }

    public String getCompanyId() {
        return companyId;
    }

    public void setCompanyId(String companyId) {
        this.companyId = companyId;
    }

    public String getConfirmer() {
        return confirmer;
    }

    public void setConfirmer(String confirmer) {
        this.confirmer = confirmer;
    }

    public Long getConfirmDate() {
        return confirmDate;
    }

    public void setConfirmDate(Long confirmDate) {
        this.confirmDate = confirmDate;
    }


    public String getCommercialinsurancenum() {
        return commercialinsurancenum;
    }

    public void setCommercialinsurancenum(String commercialinsurancenum) {
        this.commercialinsurancenum = commercialinsurancenum;
    }

    public Long getContractstartinsurance() {
        return contractstartinsurance;
    }

    public void setContractstartinsurance(Long contractstartinsurance) {
        this.contractstartinsurance = contractstartinsurance;
    }

    public String getCompulsoryinsurancenum() {
        return compulsoryinsurancenum;
    }

    public void setCompulsoryinsurancenum(String compulsoryinsurancenum) {
        this.compulsoryinsurancenum = compulsoryinsurancenum;
    }

    public Long getContractstopinsurance() {
        return contractstopinsurance;
    }

    public void setContractstopinsurance(Long contractstopinsurance) {
        this.contractstopinsurance = contractstopinsurance;
    }

    public String getIsccompulsoryinsurance() {
        return isccompulsoryinsurance;
    }

    public void setIsccompulsoryinsurance(String isccompulsoryinsurance) {
        this.isccompulsoryinsurance = isccompulsoryinsurance;
    }
}
